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