UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4JwkDSChkC/Y84OC/Sem46fV36YU7C6iUeA3nbtgxP8='
WHERE
key_id = '71a7637e1bded88ac7c77a2df5c83282e5c9566a3628020996c48905a9fc53fe'
AND (
token = '4JwkDSChkC/Y84OC/Sem46fV36YU7C6iUeA3nbtgxP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)