UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lIf8S5eOu8XGkaAMNmv27NZdA5R5vGMNrTzpUi/tB3g='
WHERE
key_id = '09e57026c3181fc3935a3ac0e867603f4b1c94e84a7378a31713a5ec38406320'
AND (
token = 'lIf8S5eOu8XGkaAMNmv27NZdA5R5vGMNrTzpUi/tB3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)