UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7NFPus9ZmGnC/vyKJC/8KvoLh0JAG/W8hT6OZxchfs='
WHERE
key_id = '1a98ab583507b296b893dce83e1cd115e28329d5d1cfea199f618684a80b8cee'
AND (
token = 'p7NFPus9ZmGnC/vyKJC/8KvoLh0JAG/W8hT6OZxchfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)