UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H5KlntY8XnK23pNMxdJiQEtl9Se+qAL0dWp6zIQyqEA='
WHERE
key_id = '1f8d85691faa278c2ea24fea3e4cb31d28163fe2ddd02262d7e98212303fefe8'
AND (
token = 'H5KlntY8XnK23pNMxdJiQEtl9Se+qAL0dWp6zIQyqEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)