UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L6QRPXAr++Xc24+BZ1crEzujfPn48tRkAZqjfaRdcwU='
WHERE
key_id = 'e67606a46acf6883b3b9eae2ead48f8be754deb49317266804c864da8ce2f93a'
AND (
token = 'L6QRPXAr++Xc24+BZ1crEzujfPn48tRkAZqjfaRdcwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)