UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8o/1q0nXC88x1haTEMvt/13tujkA3zNApRgxtux4oA4='
WHERE
key_id = '6c86ee2e777b4bd00dbcaa11ea265031abbb731f7895e4c63d429f98d7bfda59'
AND (
token = '8o/1q0nXC88x1haTEMvt/13tujkA3zNApRgxtux4oA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)