UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sq99zINw4W/hWNaWZJ2wcl6lxNrF55ML6mX5sKusfPw='
WHERE
key_id = '6526be8163a2857a994a2b9fae02487d3660c9179e1a7a00f29301055aa0de00'
AND (
token = 'sq99zINw4W/hWNaWZJ2wcl6lxNrF55ML6mX5sKusfPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)