UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEJd9bY/jF/FCmqCh5ibsUlnrUurlZ1WX4Vpa51BvmI='
WHERE
key_id = 'f9da4a176a8dd49ba654561cd26a74fea6b4e2309b0ccf24bf87887c5dd99b86'
AND (
token = 'gEJd9bY/jF/FCmqCh5ibsUlnrUurlZ1WX4Vpa51BvmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)