UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47nXoUyfMky+C/ITLwxjKhVDjk3SD09PWFAvdVJNtmI='
WHERE
key_id = '20534819795185537722c82cd14c86a3f4b0f38a50096666d7e030f2b815d4e0'
AND (
token = '47nXoUyfMky+C/ITLwxjKhVDjk3SD09PWFAvdVJNtmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)