UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cUyoGSAJGmiNHlqUhUTWqfID51W0HlS91pNN4/g9nM='
WHERE
key_id = '501c71af15edc1733209e27a82f8d2def4b01bd9374518332ddccde594a87683'
AND (
token = '9cUyoGSAJGmiNHlqUhUTWqfID51W0HlS91pNN4/g9nM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)