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