UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oZTYJmQmwUNM/Yq5vi+V4EaAcKaXirDlcW7ITV06ypo='
WHERE
key_id = 'beadf490e2ea044ed0c562cb5a2384afc73f3424b5be16f00c78fad7fe28314b'
AND (
token = 'oZTYJmQmwUNM/Yq5vi+V4EaAcKaXirDlcW7ITV06ypo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)