UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gzs7U1G1CS3krENZXeaKJk1t6OFx/txc9oFd+LJKkCQ='
WHERE
key_id = 'ed327c10c662d119503eda00188cea711f07207f17a7637c5c72b8fb173a0589'
AND (
token = 'gzs7U1G1CS3krENZXeaKJk1t6OFx/txc9oFd+LJKkCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)