UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dzz8xJozkhTQFf3IdAnMthgvpM9IZLBYNfnb9sGLjJ0='
WHERE
key_id = '7067dfaa8ff8914fd090b46ef40141278123431d8af46cd6fb81e71a6b951b93'
AND (
token = 'dzz8xJozkhTQFf3IdAnMthgvpM9IZLBYNfnb9sGLjJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)