UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PX2Y6DCJBYEfRmG3BYLKNENJI7NxMLFSBATZw9L75+8='
WHERE
key_id = 'afd1e3ff2c98517bd0e616c9b7c0427cb66484cd06804e1dd051fce1fdf19cc2'
AND (
token = 'PX2Y6DCJBYEfRmG3BYLKNENJI7NxMLFSBATZw9L75+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)