UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nO5oVjcWuc+HVxzccNHwxvObhRKiJsejevmLopj74bI='
WHERE
key_id = '1c9bbb40c216f98ac01d3e31a13933ea84ff407a06eba3c7b8717501afcd5e7f'
AND (
token = 'nO5oVjcWuc+HVxzccNHwxvObhRKiJsejevmLopj74bI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)