UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NVtWjP4EXl31x3leqGgc+nClJDfRJLyj1cCNfiD3EMM='
WHERE
key_id = 'f606b9df2ae57243e92e12f0ad5a02e6a2f42dfca92d339f2d871946721ee95a'
AND (
token = 'NVtWjP4EXl31x3leqGgc+nClJDfRJLyj1cCNfiD3EMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)