UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vvT3kqadCsqvtzwNiWKVgZmm9KbqGU3VPKiCBHBkQdo='
WHERE
key_id = '46d9c7b34a6f62a69188a6f190700a238a601c5d80130d0eb2ff19b4c2b26190'
AND (
token = 'vvT3kqadCsqvtzwNiWKVgZmm9KbqGU3VPKiCBHBkQdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)