UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGty88HQb9H3Ffg0YQbuvVVsvrxoQNquHqYdThq+OkE='
WHERE
key_id = 'c271ebff54a1dfe2399380ab2336cf2e3ec5e3521b05ff653dd5e2fd6b5da809'
AND (
token = 'zGty88HQb9H3Ffg0YQbuvVVsvrxoQNquHqYdThq+OkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)