UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y4z/1Uh6E9ERaC0nqfUcfoQrVdiJXvyW5qB7t1Fvaw4='
WHERE
key_id = '677555cf0402d87e2a2aafe3d84d10d96d7ef21ab2622d6e01a9dc176202c895'
AND (
token = 'Y4z/1Uh6E9ERaC0nqfUcfoQrVdiJXvyW5qB7t1Fvaw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)