UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kk7gfWd+W08NwuY3Mw/3uMARZ9PvDo1lGblufW23Wuc='
WHERE
key_id = '9f6c190531543e7b214b41c797aa0fff9e57957aa318054c0dd7124259942a29'
AND (
token = 'kk7gfWd+W08NwuY3Mw/3uMARZ9PvDo1lGblufW23Wuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)