UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6lcIvRFS228NoPMrVX/NrddY58EipX7cuAiHAdV5ao0='
WHERE
key_id = '87e4a522f07e74842820bcf4cb1cea4999110c6f1b2ec8453e0e8a4f7ce60be9'
AND (
token = '6lcIvRFS228NoPMrVX/NrddY58EipX7cuAiHAdV5ao0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)