UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r1H2YODNH4u2JVn9DL6ZRLnYORmb2T0SWf1Um77f/Kc='
WHERE
key_id = 'f6e08511ed0089232413b4ea9394869670a6dd1e1acc8ef0d232035c05af4373'
AND (
token = 'r1H2YODNH4u2JVn9DL6ZRLnYORmb2T0SWf1Um77f/Kc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)