UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0qVwSFg/FXEGxq+vLUaNv03NE3yEo6FuC29Erv291Wk='
WHERE
key_id = '20dfbc14b8be43564ae8dff0bc849e4a76047d11d757388dcdfb54080b00b73c'
AND (
token = '0qVwSFg/FXEGxq+vLUaNv03NE3yEo6FuC29Erv291Wk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)