UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R7cNRp1Y80NwnsGKLnEoA3SWHLokx6a23x1shtb5rM0='
WHERE
key_id = '0b40ce0577d89430ccc153b80a9fbdf86035a0824b6708a40d9ee509aa1fdefb'
AND (
token = 'R7cNRp1Y80NwnsGKLnEoA3SWHLokx6a23x1shtb5rM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)