UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PiCcPLMDJ0q7rodilZaUHDNKwdb0ibsrl0dxj2eoNPQ='
WHERE
key_id = '7e2b4512ced44b8ed78ba16e983e39c5cf61e0e4573eeb48b5754888b52ec197'
AND (
token = 'PiCcPLMDJ0q7rodilZaUHDNKwdb0ibsrl0dxj2eoNPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)