UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pcgeiTJk5asCtjnSkTaImA3xCRQI0pLVdlDZ0PP3iJ0='
WHERE
key_id = 'b0c53d8aa01f3df92d4fac6077ffc9e3ba6600c277818fbb8adfb7d3764a7ea2'
AND (
token = 'pcgeiTJk5asCtjnSkTaImA3xCRQI0pLVdlDZ0PP3iJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)