UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BmRfLcOu45NfQCSc4dWJu2QX0MLJyC0vBm41aIGSWXk='
WHERE
key_id = 'd139c16341d93258738ec4fa8c32fc1c907a84cca2e203bb663e50bf123409a8'
AND (
token = 'BmRfLcOu45NfQCSc4dWJu2QX0MLJyC0vBm41aIGSWXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)