UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNxbQ7+PuYWKa1f46YANDNkOD3ETGW9OYTRq8Y2//mk='
WHERE
key_id = '4e4710bc7015567817e912b060c71946df2f7f47f7da52b870a94668fbfa1dd1'
AND (
token = 'KNxbQ7+PuYWKa1f46YANDNkOD3ETGW9OYTRq8Y2//mk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)