UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E2Lr2OW0YaHHfSNYbPVyYiC/jU0AVoc7ourXzb19jM8='
WHERE
key_id = '1c1afa47413f03ce08fe99b1f8faa2f9f766cd6397039cee17f113fde10b42f7'
AND (
token = 'E2Lr2OW0YaHHfSNYbPVyYiC/jU0AVoc7ourXzb19jM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)