UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5YgaBANfCr/QQlHg2axazgFzCt2Apo5HCdRtKLeXlnc='
WHERE
key_id = '0cc6e54855a1cad883ecdf25769b092e312ed6bcaa86d69a90628164d790a3a0'
AND (
token = '5YgaBANfCr/QQlHg2axazgFzCt2Apo5HCdRtKLeXlnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)