UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f/nJeJ5EsCYUQsnx3NuB5SJaQzzrNr9/K6upw8hngZs='
WHERE
key_id = '31b1906ae779667b73c937f323882b0e65828b479c7d6d3bf35d1159120fb09b'
AND (
token = 'f/nJeJ5EsCYUQsnx3NuB5SJaQzzrNr9/K6upw8hngZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)