UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kz0u8GveSZMRfWd5MXh+GMyub6BY6Z4196jPJ3vixjg='
WHERE
key_id = 'e52375083d381764b13ed03cb048e8405512807a97a8b7b3cd1242fd90a8e700'
AND (
token = 'kz0u8GveSZMRfWd5MXh+GMyub6BY6Z4196jPJ3vixjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)