UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XbNK8VYiISvdYW3/Ey1QKdva0qPSmFSeAOvUBKUT9Tk='
WHERE
key_id = '06f04e8c7feee0cde7efb99a72a661830a8d8a5add3ce89ea833935b9ab9d2ee'
AND (
token = 'XbNK8VYiISvdYW3/Ey1QKdva0qPSmFSeAOvUBKUT9Tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)