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