UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49iFcdjP7Xc6YwbMXyo+rDSSTfh0JIhx5b8aDt3QyVc='
WHERE
key_id = '6a28c2ec42af321364108d4957437a2bc0dcc59d153a2712bfe1cf710d022c3e'
AND (
token = '49iFcdjP7Xc6YwbMXyo+rDSSTfh0JIhx5b8aDt3QyVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)