UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H3/GnpXMdlkpydUL5izxwNwEg995qw0jXZWvqfE9GmU='
WHERE
key_id = '511e78067d7d2f1379159f723076731e360c4161a3f3de03172350ed6aa97ea5'
AND (
token = 'H3/GnpXMdlkpydUL5izxwNwEg995qw0jXZWvqfE9GmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)