UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9KV03l/8pYmXgHiphfgkJCu3BhZheDXi4M/YT7/Md8s='
WHERE
key_id = 'fae98cb940e96296a3c00123b322087d4bc50983e68329da79105ad18c4df517'
AND (
token = '9KV03l/8pYmXgHiphfgkJCu3BhZheDXi4M/YT7/Md8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)