UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NT3qdcZ2zaGI1l+RxBHU0y8b93eC2FKpUI7k+108Rvk='
WHERE
key_id = '9dc53442d9b08a6b3413816f06b799583d0a3e570f78072f3b2820f55000f120'
AND (
token = 'NT3qdcZ2zaGI1l+RxBHU0y8b93eC2FKpUI7k+108Rvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)