UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5WqpbY1emjAPt5rF39vnzvCoTXz8eEbl6yp5be1HuKg='
WHERE
key_id = '9a1018bf437bf5e643dde62cd424518e401b7d5ae26d9bf7d63159cfa4234bc8'
AND (
token = '5WqpbY1emjAPt5rF39vnzvCoTXz8eEbl6yp5be1HuKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)