UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Z0iU1RfxSG8usiWX1VLj/ngyBuUAICc01A7xjc5yWg='
WHERE
key_id = 'b66e010c385ca7704183231ced2028387b69b9f1c0439851e9e2a021e95d35db'
AND (
token = '6Z0iU1RfxSG8usiWX1VLj/ngyBuUAICc01A7xjc5yWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)