UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4gm+0iT4saZPcPS9oU6I6QCRDOjEq5bdLBsVkSE6fQ8='
WHERE
key_id = '6d9303189bbb7595893c96e19fe6ae0887bb9c682c2601729f2aba522684936e'
AND (
token = '4gm+0iT4saZPcPS9oU6I6QCRDOjEq5bdLBsVkSE6fQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)