UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8xYNkEdH6HfDHWo6M1WO6oPDw4wINTBk478vSfUufA='
WHERE
key_id = '47ffbac4cada28e15e4e233c24f7aef2cd0420df55d6b750c83f7ff7f8351313'
AND (
token = 'C8xYNkEdH6HfDHWo6M1WO6oPDw4wINTBk478vSfUufA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)