UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXIOTEo0NBaPStjs0prEBwxb5GmmgAEk6zDvdws3QbU='
WHERE
key_id = '0d974ff7cfbcc3a86ef9979c7dbdee60ab038f2a45bda23c2422b35814192514'
AND (
token = 'PXIOTEo0NBaPStjs0prEBwxb5GmmgAEk6zDvdws3QbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)