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