UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fnKwmZIi49ImYiEDLc49TqNF5IfvdoYNr9ZjPd/JYZI='
WHERE
key_id = '0a2772128b49c51a0296389da02c76cc35cf1e2a4d9383f2fbf86bbc4afcd96b'
AND (
token = 'fnKwmZIi49ImYiEDLc49TqNF5IfvdoYNr9ZjPd/JYZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)