UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oNMt6wRECdJpcHfq4G+fZj0B+vudegkaKYy0iMdDmD8='
WHERE
key_id = 'add9dccc3941b83233dc1336109b53dc7ec02cebc251a3a07c3e6b034a3b8dd0'
AND (
token = 'oNMt6wRECdJpcHfq4G+fZj0B+vudegkaKYy0iMdDmD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)