UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prBVSYk0XDfko7JZjkJ3G+Y3Mu3u/1UywHsp5Za5FCM='
WHERE
key_id = 'ab6214cf080a25088690026b0922b83254ef820a0cdfa52fad8ac8b6a3272224'
AND (
token = 'prBVSYk0XDfko7JZjkJ3G+Y3Mu3u/1UywHsp5Za5FCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)