UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pR7mL+5SahXxdvYvP3khNtWccG9nxf0g2u07zlG3lg8='
WHERE
key_id = '45a6a93219d314f3aa4e6c110e01b51392bc96d9e50bbc7490cbe963c8199133'
AND (
token = 'pR7mL+5SahXxdvYvP3khNtWccG9nxf0g2u07zlG3lg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)