UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPhqY+SdcB+sahNECR/Ocql6j9WDAArvWSe3+bRW1eg='
WHERE
key_id = '016f8b62dc384a33de2f22254f8e8ea830f3d7119051e129f7ee62532c53c996'
AND (
token = 'lPhqY+SdcB+sahNECR/Ocql6j9WDAArvWSe3+bRW1eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)